package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.*;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface SalesMapper {
    //sales:查询购物车产品
    public List<Cart> selectCart(@Param("salesId") int salesId);
    //sales:查询销售机会
    public List<Sales> selectSales(@Param("ygId") Integer ygId,@Param("salesId") int salesId,@Param("salesTheme") String salesTheme,@Param("salesStage") String salesStage);
    //sales:查询产品
    public List<Stock> productSelect(@Param("categoryId") long categoryId,@Param("cpName") String cpName);
    public List<ProductXq> productSelect1();
    //option:solution:查询解决方案
    public List<Solution> selectSolution(@Param("salesId") int salesId);
    //option:solution:删除解决方案
    public void updateSolution(@Param("solutionState") String solutionState,@Param("solutionId") int solutionId);
    //competitor:查询竞争对手
    public List<Competitor> selectCompetitor(@Param("salesId") int salesId,@Param("compeCompany") String compeCompany);
    //offer:查询报价，报价详单，购物车
    public List<Offer> selectOffer(@Param("salesId") int salesId);
    //funnel:漏斗图
    public List<Sales> create(@Param("ygId") int ygId);
    //option:follow:查询跟进记录
    public List<Follow> selectFollow(@Param("salesId") int salesId);
    //print：报价查询
    public List<Offer> printOffer(@Param("offerId") int offerId);
    //print：报价详情查询
    public List<OfferDetail> offerDetailPrint(@Param("offerId") int offerId);
    //查询审核表
    public Check selectCheck(@Param("typeId") int typeId);
    //主页查询销售漏斗
    public List<Sales> select1();
    //统计商机
    public List<Shuliang> selectsales();
}
